﻿CREATE TABLE [dbo].[LIENHE] (
    [IdDoiTuong]       UNIQUEIDENTIFIER NOT NULL,
    [MaHieu]           NCHAR (100)      NOT NULL,
    [XungHo]           NCHAR (100)      NULL,
    [HoVaDem]          NCHAR (100)      NULL,
    [Ten]              NCHAR (100)      NULL,
    [HoVaTen]          NCHAR (100)      NOT NULL,
    [MaToChuc]         NCHAR (100)      NOT NULL,
    [ChucDanh]         NCHAR (100)      NULL,
    [TelCQ]            CHAR (20)        NULL,
    [Fax]              CHAR (20)        NULL,
    [Mobile]           CHAR (20)        NULL,
    [MobileKhac]       CHAR (20)        NULL,
    [TelNR]            CHAR (20)        NULL,
    [TelKhac]          CHAR (20)        NULL,
    [Email]            CHAR (50)        NULL,
    [PhongBan]         NCHAR (100)      NULL,
    [TroLy]            NCHAR (100)      NULL,
    [TelTroLy]         CHAR (20)        NULL,
    [NguonGoc]         NCHAR (100)      NULL,
    [NgaySinh]         DATETIME         NOT NULL,
    [DienGiai]         NVARCHAR (100)   NULL,
    [KoEmail]          BIT              NOT NULL,
    [KoGoiDien]        BIT              NOT NULL,
    [NgayTao]          DATETIME         NOT NULL,
    [IdDiaChiCoQuan]   INT              NULL,
    [IdDiaChiNhaRieng] INT              NULL
);

